Discogs Analysis

Discogs Developer

Download Discogs Data

Discogs Database Search

Discogs Oauth

Need data on location of purchase

Key Questions to answer:

• What is the profile of my record collection?

• What are the most expensive records and CDs I own?

• Which band/artist do I own the most and what is the cost of that?

• Which record label do I support the most and which did I spent the most?

• Which subgenre costs the most and which one is worth the most?

• Is there a difference between autographed and non-authographed records?

• What is the breakdown of the format and the cost, min price, median price, and max price?

	ID	Catalog#	Artist	Artist2	Title	Label	Format	Rating	Released	release_id	CollectionFolder	Date Added	Collection Media Condition	Collection Sleeve Condition	Collection Notes	Collection Cost	Collection Autographed	Min	Median	Max	Genre	Subgenre
0	33	SD 8283	Yes	Yes	The Yes Album	Atlantic	LP, Album, RE, PR;	NaN	1971	7116823.0	Vinyl	7/21/19 20:21	NaN	NaN	NaN	5.50	NaN	2.25	3.87	10.00	Rock	Progressive Rock
1	165	RR 6583-1	Mastodon	Mastodon	Remission	Relapse Records	2x12", Album, RE, RM, RP	NaN	2017	8863478.0	Vinyl	12/3/16 11:44	NaN	NaN	NaN	15.00	NaN	7.99	21.67	30.19	Metal	Sludge Metal
2	373	CS 8192	The Dave Brubeck Quartet	The Dave Brubeck Quartet	Time Out	Columbia	LP, Album	NaN	1961	2676016.0	Vinyl	5/5/14 21:16	NaN	NaN	NaN	20.00	NaN	5.07	26.50	130.00	Jazz	Jazz
3	142	SD 3-100	Yes	Yes	Yessongs	Atlantic	3xLP, Album	5.0	1973	8179158.0	Vinyl	4/20/17 19:05	NaN	NaN	NaN	5.00	NaN	3.95	9.99	20.00	Rock	Progressive Rock
4	18	SD 2-908	Yes	Yes	Tales From Topographic Oceans	Atlantic	2xLP, Album, Gat	NaN	1973	8535940.0	Vinyl	2/22/20 15:50	NaN	NaN	NaN	5.50	NaN	7.99	13.49	20.00	Rock	Progressive Rock
5	340	SD 18122	Yes	Yes	Relayer	Atlantic	LP, Album, Gat	NaN	1974	755646.0	Vinyl	9/6/14 11:59	NaN	NaN	NaN	4.00	NaN	1.13	7.00	30.74	Rock	Progressive Rock
6	374	SD 8245	King Crimson	King Crimson	In The Court Of The Crimson King An Observati...	Atlantic	LP, Album, RE, PRC	NaN	1975	4254321.0	Vinyl	5/5/14 21:14	NaN	NaN	NaN	12.00	NaN	10.00	17.00	25.00	Rock	Progressive Rock
7	255	34224, PZ 34224	Kansas (2)	Kansas (2)	Leftoverture	Kirshner, Kirshner	LP, Album	3.0	1976	1476710.0	Vinyl	8/9/15 18:25	NaN	NaN	NaN	0.86	NaN	1.72	3.82	9.95	Rock	Classic Rock
8	341	SD 19132	Yes	Yes	Fragile	Atlantic	LP, Album, RE, SRC	NaN	1977	2637700.0	Vinyl	9/6/14 11:59	NaN	NaN	NaN	4.00	NaN	4.50	7.25	14.00	Rock	Progressive Rock
9	19	AFL1-3516	Scorpions	Scorpions	Best Of Scorpions	RCA Victor	LP, Comp	NaN	1979	3632339.0	Vinyl	2/22/20 15:47	NaN	NaN	NaN	2.00	NaN	4.50	7.99	14.99	Metal	Heavy Metal

Some of the labels are separated by commas.

	ID	Catalog#	Artist	Artist2	Title	Label	Format	Rating	Released	release_id	CollectionFolder	Date Added	Collection Media Condition	Collection Sleeve Condition	Collection Notes	Collection Cost	Collection Autographed	Min	Median	Max	Genre	Subgenre	0	1	2	3
0	33	SD 8283	Yes	Yes	The Yes Album	Atlantic	LP, Album, RE, PR;	NaN	1971	7116823.0	Vinyl	7/21/19 20:21	NaN	NaN	NaN	5.50	NaN	2.25	3.87	10.00	Rock	Progressive Rock	Atlantic	None	None	None
1	165	RR 6583-1	Mastodon	Mastodon	Remission	Relapse Records	2x12", Album, RE, RM, RP	NaN	2017	8863478.0	Vinyl	12/3/16 11:44	NaN	NaN	NaN	15.00	NaN	7.99	21.67	30.19	Metal	Sludge Metal	Relapse Records	None	None	None
2	373	CS 8192	The Dave Brubeck Quartet	The Dave Brubeck Quartet	Time Out	Columbia	LP, Album	NaN	1961	2676016.0	Vinyl	5/5/14 21:16	NaN	NaN	NaN	20.00	NaN	5.07	26.50	130.00	Jazz	Jazz	Columbia	None	None	None
3	142	SD 3-100	Yes	Yes	Yessongs	Atlantic	3xLP, Album	5.0	1973	8179158.0	Vinyl	4/20/17 19:05	NaN	NaN	NaN	5.00	NaN	3.95	9.99	20.00	Rock	Progressive Rock	Atlantic	None	None	None
4	18	SD 2-908	Yes	Yes	Tales From Topographic Oceans	Atlantic	2xLP, Album, Gat	NaN	1973	8535940.0	Vinyl	2/22/20 15:50	NaN	NaN	NaN	5.50	NaN	7.99	13.49	20.00	Rock	Progressive Rock	Atlantic	None	None	None
5	340	SD 18122	Yes	Yes	Relayer	Atlantic	LP, Album, Gat	NaN	1974	755646.0	Vinyl	9/6/14 11:59	NaN	NaN	NaN	4.00	NaN	1.13	7.00	30.74	Rock	Progressive Rock	Atlantic	None	None	None
6	374	SD 8245	King Crimson	King Crimson	In The Court Of The Crimson King An Observati...	Atlantic	LP, Album, RE, PRC	NaN	1975	4254321.0	Vinyl	5/5/14 21:14	NaN	NaN	NaN	12.00	NaN	10.00	17.00	25.00	Rock	Progressive Rock	Atlantic	None	None	None
7	255	34224, PZ 34224	Kansas (2)	Kansas (2)	Leftoverture	Kirshner, Kirshner	LP, Album	3.0	1976	1476710.0	Vinyl	8/9/15 18:25	NaN	NaN	NaN	0.86	NaN	1.72	3.82	9.95	Rock	Classic Rock	Kirshner	Kirshner	None	None
8	341	SD 19132	Yes	Yes	Fragile	Atlantic	LP, Album, RE, SRC	NaN	1977	2637700.0	Vinyl	9/6/14 11:59	NaN	NaN	NaN	4.00	NaN	4.50	7.25	14.00	Rock	Progressive Rock	Atlantic	None	None	None
9	19	AFL1-3516	Scorpions	Scorpions	Best Of Scorpions	RCA Victor	LP, Comp	NaN	1979	3632339.0	Vinyl	2/22/20 15:47	NaN	NaN	NaN	2.00	NaN	4.50	7.99	14.99	Metal	Heavy Metal	RCA Victor	None	None	None
10	143	MCA 1688, MCA-1688	Steely Dan	Steely Dan	Aja	MCA Records, MCA Records	LP, Album, RE	5.0	1980	2457672.0	Vinyl	4/20/17 19:03	NaN	NaN	NaN	5.00	NaN	2.00	8.99	29.95	Rock	Classic Rock	MCA Records	MCA Records	None	None
11	17	SD 16019	Yes	Yes	Drama	Atlantic	LP, Album, Gat	NaN	1980	10123561.0	Vinyl	2/22/20 15:52	NaN	NaN	NaN	4.00	NaN	2.00	4.55	11.00	Rock	Progressive Rock	Atlantic	None	None	None
12	149	422-811 492-1 M-1, 811492-1 M-1	Various	Various	Flashdance (Original Soundtrack From The Motio...	Casablanca, Casablanca	LP, Album, 26	4.0	1983	2969044.0	Vinyl	4/2/17 18:00	NaN	NaN	NaN	2.00	NaN	1.00	2.60	5.49	Electronic	Synthpop	Casablanca	Casablanca	None	None
13	256	GHS 24099	Whitesnake	Whitesnake	Whitesnake	Geffen Records	LP, Album	3.0	1987	383094.0	Vinyl	8/9/15 18:23	NaN	NaN	NaN	0.50	NaN	5.50	9.05	21.49	Rock	Classic Rock	Geffen Records	None	None	None
14	275	RR 6427-2	The Dillinger Escape Plan	The Dillinger Escape Plan	Calculating Infinity	Relapse Records	CD, Album	NaN	1999	5536513.0	CD	6/12/15 18:44	NaN	NaN	NaN	1.00	NaN	0.86	5.51	11.99	Metal	Progressive Metal	Relapse Records	None	None	None
15	182	HH666-52	Cave In	Cave In	Jupiter	Hydra Head Records	CD, Album	NaN	2000	416414.0	CD	9/20/16 18:42	NaN	NaN	NaN	2.00	NaN	4.02	6.85	8.91	Metal	Hardcore	Hydra Head Records	None	None	None
16	375	IPC-32	Isis (6)	Isis (6)	Oceanic	Ipecac Recordings	CD, Album	NaN	2002	376473.0	CD	3/25/14 19:51	NaN	NaN	NaN	7.00	NaN	4.58	6.33	12.97	Metal	Post Metal	Ipecac Recordings	None	None	None
17	193	J1PV-55425-1	Wyclef Jean	Wyclef Jean	The Preacher's Son	J Records	2xLP, Promo	NaN	2003	2092873.0	Vinyl	6/9/16 11:15	NaN	NaN	Sell	0.50	NaN	1.88	3.88	10.00	Hip Hop	Hip Hop	J Records	None	None	None
18	146	TZ 7092	Kayo Dot	Kayo Dot	Choirs Of The Eye	Tzadik	CD, Album, Cre	5.0	2003	649369.0	CD	4/2/17 18:17	NaN	NaN	NaN	15.00	Yes	6.66	10.19	16.37	Metal	Progressive Metal	Tzadik	None	None	None
19	264	EK 93480	Chevelle (2)	Chevelle (2)	This Type Of Thinking (Could Do Us In)	Epic	CD, Album	NaN	2004	2751295.0	CD	7/14/15 8:39	NaN	NaN	NaN	10.00	NaN	1.59	2.29	2.99	Rock	Alternative Rock	Epic	None	None	None

Rename columns

	ID	Catalog#	Artist	Artist2	Title	Label	Format	Rating	Released	release_id	CollectionFolder	Date Added	Collection Media Condition	Collection Sleeve Condition	Collection Notes	Collection Cost	Collection Autographed	Min	Median	Max	Genre	Subgenre	Label1	Label2	Label3	Label4
0	33	SD 8283	Yes	Yes	The Yes Album	Atlantic	LP, Album, RE, PR;	NaN	1971	7116823.0	Vinyl	7/21/19 20:21	NaN	NaN	NaN	5.5	NaN	2.25	3.87	10.00	Rock	Progressive Rock	Atlantic	None	None	None
1	165	RR 6583-1	Mastodon	Mastodon	Remission	Relapse Records	2x12", Album, RE, RM, RP	NaN	2017	8863478.0	Vinyl	12/3/16 11:44	NaN	NaN	NaN	15.0	NaN	7.99	21.67	30.19	Metal	Sludge Metal	Relapse Records	None	None	None
2	373	CS 8192	The Dave Brubeck Quartet	The Dave Brubeck Quartet	Time Out	Columbia	LP, Album	NaN	1961	2676016.0	Vinyl	5/5/14 21:16	NaN	NaN	NaN	20.0	NaN	5.07	26.50	130.00	Jazz	Jazz	Columbia	None	None	None
3	142	SD 3-100	Yes	Yes	Yessongs	Atlantic	3xLP, Album	5.0	1973	8179158.0	Vinyl	4/20/17 19:05	NaN	NaN	NaN	5.0	NaN	3.95	9.99	20.00	Rock	Progressive Rock	Atlantic	None	None	None
4	18	SD 2-908	Yes	Yes	Tales From Topographic Oceans	Atlantic	2xLP, Album, Gat	NaN	1973	8535940.0	Vinyl	2/22/20 15:50	NaN	NaN	NaN	5.5	NaN	7.99	13.49	20.00	Rock	Progressive Rock	Atlantic	None	None	None

Export for inspection

Label Sorting

Label must be sorted. There is an issue like this where Svart Records is placed before 20 Buck Spin

	ID	Catalog#	Artist	Artist2	Title	Label	Format	Rating	Released	release_id	CollectionFolder	Date Added	Collection Media Condition	Collection Sleeve Condition	Collection Notes	Collection Cost	Collection Autographed	Min	Median	Max	Genre	Subgenre	Label1	Label2	Label3	Label4
154	88	SPIN065	Mournful Congregation	Mournful Congregation	Concrescence Of The Sophia	20 Buck Spin	LP, MiniAlbum	NaN	2014	5807031.0	Vinyl	6/3/18 15:21	NaN	NaN	NaN	17.0	NaN	6.00	9.00	15.99	Metal	Doom Metal	20 Buck Spin	None	None	None
215	156	SPIN075	Khemmis	Khemmis	Absolution	20 Buck Spin	LP, Album, RP	NaN	2015	8551023.0	Vinyl	1/18/17 15:05	NaN	NaN	NaN	18.0	Yes	10.00	19.49	24.99	Metal	Doom Metal	20 Buck Spin	None	None	None
239	213	SPIN048	Pallbearer	Pallbearer	Sorrow And Extinction	20 Buck Spin	2xLP, Album, RP, Blu	4.0	2015	6825240.0	Vinyl	2/26/16 11:05	NaN	NaN	NaN	15.0	NaN	20.00	29.43	36.30	Metal	Doom Metal	20 Buck Spin	None	None	None
259	157	SPIN076	Khemmis	Khemmis	Hunted	20 Buck Spin	LP, Album	NaN	2016	9222656.0	Vinyl	1/18/17 15:05	NaN	NaN	NaN	18.0	Yes	10.00	15.00	23.33	Metal	Doom Metal	20 Buck Spin	None	None	None
283	14	SVART003, SPIN 080	Oranssi Pazuzu	Oranssi Pazuzu	Värähtelijä	Svart Records, 20 Buck Spin	2xLP, Ltd, Blu	NaN	2016	11636087.0	Vinyl	2/22/20 15:59	NaN	NaN	NaN	25.0	NaN	20.00	24.17	26.37	Metal	Black Metal	Svart Records	20 Buck Spin	None	None
285	133	SPIN072	Obsequiae	Obsequiae	Aria Of Vernal Tombs	20 Buck Spin	LP, Album, Cle	NaN	2016	8556349.0	Vinyl	4/27/17 18:58	NaN	NaN	NaN	15.0	NaN	20.78	28.50	36.66	Metal	Black Metal	20 Buck Spin	None	None	None
311	91	SPIN091	Acephalix	Acephalix	Decreation	20 Buck Spin	LP, Album	NaN	2017	10946608.0	Vinyl	5/29/18 18:20	NaN	NaN	NaN	15.0	NaN	11.90	18.50	27.47	Metal	Death Metal	20 Buck Spin	None	None	None
322	71	SVR226, SPIN059	Oranssi Pazuzu	Oranssi Pazuzu	Valonielu	Svart Records, 20 Buck Spin	LP, Album, RE	NaN	2017	10341101.0	Vinyl	12/18/18 14:36	NaN	NaN	NaN	15.0	NaN	18.71	22.06	26.56	Metal	Black Metal	Svart Records	20 Buck Spin	None	None
346	73	SPIN093	Spirit Adrift	Spirit Adrift	Curse Of Conception	20 Buck Spin	LP, Album, Oli	NaN	2018	12305606.0	Vinyl	12/18/18 12:39	NaN	NaN	NaN	15.0	NaN	12.00	21.00	23.99	Metal	Doom Metal	20 Buck Spin	None	None	None
350	79	SPIN081, OPLP338	Mournful Congregation	Mournful Congregation	The Incubus Of Karma	20 Buck Spin, Osmose Productions	2xLP, Album, Ltd	5.0	2018	11750808.0	Vinyl	8/4/18 8:30	NaN	NaN	NaN	27.0	Yes	14.00	20.32	23.91	Metal	Doom Metal	20 Buck Spin	Osmose Productions	None	None
355	53	SPIN045, OPLP264	Mournful Congregation	Mournful Congregation	The Book Of Kings	20 Buck Spin, Osmose Productions	2xLP, Album, RP	NaN	2018	13018313.0	Vinyl	5/27/19 12:39	NaN	NaN	NaN	16.0	NaN	15.00	19.75	26.30	Metal	Doom Metal	20 Buck Spin	Osmose Productions	None	None
369	74	SPIN101LP	Tomb Mold	Tomb Mold	Manor Of Infinite Forms	20 Buck Spin	LP, Album, Ltd, Ora	NaN	2018	12090041.0	Vinyl	8/16/18 12:47	NaN	NaN	NaN	15.0	NaN	23.40	35.00	50.00	Metal	Death Metal	20 Buck Spin	None	None	None
388	36	SPIN112	Immortal Bird	Immortal Bird	Thrive On Neglect	20 Buck Spin	LP, Album, Ltd	NaN	2019	13835380.0	Vinyl	7/21/19 20:18	NaN	NaN	NaN	21.0	Yes	19.98	24.49	29.00	Metal	Black Metal	20 Buck Spin	None	None	None
402	10	SPIN114	Tomb Mold	Tomb Mold	Planetary Clairvoyance	20 Buck Spin	LP, Album, Ltd, Sil	NaN	2019	13909660.0	Vinyl	2/22/20 16:07	NaN	NaN	NaN	20.0	Yes	NaN	NaN	NaN	Metal	Death Metal	20 Buck Spin	None	None	None

283    Svart Records, 20 Buck Spin
322    Svart Records, 20 Buck Spin
393               Roadburn Records
Name: Label, dtype: object

['Svart Records', '20 Buck Spin']

Sort like this

['20 Buck Spin', 'Svart Records']

Drop column

Create new columns:

• Artist - Label
• pct_profit_min
• pct_profit_median
• pct_profit_max

	Artist	Label	Record
0	Yes	Atlantic	Yes - The Yes Album
1	Mastodon	Relapse Records	Mastodon - Remission
2	The Dave Brubeck Quartet	Columbia	The Dave Brubeck Quartet - Time Out
3	Yes	Atlantic	Yes - Yessongs
4	Yes	Atlantic	Yes - Tales From Topographic Oceans

Run Pandas Profiler

Here are some interesting information about my record collection:

1) I purchased around 408 albums in vinyl, CD, and tape format.
2) I have 188 unique artists in my collection. I also have 10 artists that collaborated with others.
3) My top five bands are:

Artist2	Count	Percentage
Opeth	19	4.7%
Cult Of Luna	16	3.9%
Isis (6)	12	2.9%
Panopticon (6)	11	2.7%
Between The Buried And Me	10	2.5%

4) I own 388 distinct albums.
5) In my collection, 84.3% are vinyl and 15.4\% are CD. I have 2 Tapes.

6) My top 5 genres are:

Genre	Count	Percentage
Metal	358	87.7%
Rock	31	7.6%
Electronic	12	2.9%
Pop	3	0.7%
Hip Hop	2	0.5%

7) My top 5 subgenres are:

Genre	Count	Percentage
Black Metal	83	20.3%
Progressive Metal	62	15.2%
Post Metal	61	15.0%
Djent	26	6.4%
Sludge Metal	26	6.4%

7) I typically pay \$15 (50 or 12.3\%) for a record. The next is \\$20 (49 or 12.0\%).
8) The most frequent album sold at the _Max_ price is \$29.99 (12 or 2.9\%). Next is \\$39.99 (9 or 2.2\%).

9) My top five record labels are:

Label	Count	Percentage
Relapse Records	23	5.6%
Century Media	17	4.2%
Prosthetic Records	13	3.2%
Hydra Head Records	12	2.9%
20 Buck Spin	10	2.5%

10) Most albums I buy were released in the last several years:

Year	Count	Percentage
2014	61	15.0%
2013	55	13.5%
2016	52	12.7%
2015	48	11.8%
2017	40	9.8%

Get summary statistics

	ID	Released	release_id	Collection_Cost	_Min_	_Median_	_Max_
count	408.000000	408.000000	4.070000e+02	408.000000	392.000000	392.000000	392.000000
mean	204.504902	2013.164216	7.330329e+06	18.528627	17.322449	25.659311	38.255561
std	117.932184	7.567225	3.417850e+06	14.222461	22.008193	29.396237	47.702644
min	1.000000	1961.000000	3.764730e+05	0.000000	0.860000	2.250000	2.990000
25%	102.750000	2013.000000	4.823426e+06	12.000000	8.000000	14.037500	20.000000
50%	204.500000	2015.000000	6.820328e+06	17.000000	14.980000	21.990000	29.260000
75%	306.250000	2017.000000	9.817652e+06	23.000000	21.210000	29.862500	40.000000
max	409.000000	2020.000000	1.473373e+07	232.000000	389.000000	514.170000	799.990000

Run correlation

<matplotlib.axes._subplots.AxesSubplot at 0x1273eb610>

Plot boxplot of the collection cost, minimum sold, median sold, and max sold.

<matplotlib.axes._subplots.AxesSubplot at 0x12d48fbd0>

Remove outlier

<matplotlib.axes._subplots.AxesSubplot at 0x12d493210>

<matplotlib.axes._subplots.AxesSubplot at 0x12d2c4890>

	index	0
0	Collection_Cost	7559.68
1	_Min_	6790.40
2	_Median_	10058.45
3	_Max_	14996.18

I spent $ 7559.679999999999  on music that is recorded on Discogs. 
 
My collection is worth $ 10058.45

	index	0
0	Collection_Cost	18.528627
1	_Min_	17.322449
2	_Median_	25.659311
3	_Max_	38.255561

I spent on averege $ 18.53  on per album that is recorded on Discogs. 
 
My average collection is worth $ 25.66

What is the most expensive record I bought?

	ID	Catalog#	Artist	Artist2	Title	Label	Format	Released	release_id	CollectionFolder	Date_Added	Collection_Cost	Collection_Autographed	_Min_	_Median_	_Max_	Genre	Subgenre	Label1	Label2	Label3	Label4	Record
302	187	NB 3446-5, 3446-5	Meshuggah	Meshuggah	25 Years Of Musical Deviance	Nuclear Blast, Nuclear Blast	Box, Comp, Ltd + 12", EP, RE, Cle + 2xLP, Albu...	2016	8808750.0	Vinyl	7/28/16 20:17	232.0	No	389.0	514.17	799.99	Metal	Djent	Nuclear Blast	Nuclear Blast	None	None	Meshuggah - 25 Years Of Musical Deviance

	Artist	Title	Format	Collection_Cost	_Median_	Genre	Subgenre
302	Meshuggah	25 Years Of Musical Deviance	Box, Comp, Ltd + 12", EP, RE, Cle + 2xLP, Albu...	232.0	514.17	Metal	Djent

This record has 7 full length albums and 3 EPs plus a DVD and a lyric book

The most expensive record I own is the Meshuggah - 25 Years Of Musical Deviance, Boxset.

What is the least expensive record I own?

	ID	Catalog#	Artist	Artist2	Title	Label	Format	Released	release_id	CollectionFolder	Date_Added	Collection_Cost	Collection_Autographed	_Min_	_Median_	_Max_	Genre	Subgenre	Label1	Label2	Label3	Label4	Record
87	189	Relic 009	Bunrage / Footpaths	Bunrage / Footpaths	Untitled	Haute Magie	LP, Cle	2012	3469073.0	Vinyl	6/18/16 13:22	0.0	No	NaN	NaN	NaN	Folk	Folk	Haute Magie	None	None	None	Bunrage / Footpaths - Untitled

	Artist	Title	Format	Collection_Cost	_Median_	Genre	Subgenre
87	Bunrage / Footpaths	Untitled	LP, Cle	0.0	NaN	Folk	Folk

I got this record for free from a friend

What is the least expensive record I bought?

	Artist	Title	Format	Collection_Cost	_Median_	Genre	Subgenre
13	Whitesnake	Whitesnake	LP, Album	0.5	9.05	Rock	Classic Rock
17	Wyclef Jean	The Preacher's Son	2xLP, Promo	0.5	3.88	Hip Hop	Hip Hop

I bought Wyclef Jean 2xLP at the basement of Dusty Groove for 50 cents.

What are the top 10 records I spent the most?

	CollectionFolder	Record	Genre	Subgenre	Collection_Autographed	Collection_Cost	_Min_	_Median_	_Max_
302	Vinyl	Meshuggah - 25 Years Of Musical Deviance	Metal	Djent	No	232.0	389.00	514.17	799.99
54	Vinyl	Opeth - In Live Concert At The Royal Albert Hall	Metal	Progressive Metal	No	66.0	85.99	117.83	141.76
394	Vinyl	Cult Of Luna - A Dawn To Fear	Metal	Post Metal	No	66.0	27.47	54.74	58.23
201	Vinyl	Mastodon - Remission	Metal	Sludge Metal	No	55.0	45.00	81.97	143.90
254	Vinyl	Opeth - Book Of Opeth	Metal	Progressive Metal	No	50.0	6.57	59.28	97.80
288	Vinyl	Cult Of Luna - Salvation	Metal	Post Metal	No	45.0	24.00	51.12	56.18
294	Vinyl	Cult Of Luna - Somewhere Along The Highway	Metal	Post Metal	No	45.0	28.00	59.20	79.99
303	Vinyl	Sioum - Yet Further	Metal	Progressive Metal	No	40.0	NaN	NaN	NaN
122	Vinyl	Opeth - Ghost Reveries	Metal	Progressive Metal	No	40.0	20.00	24.98	32.18
202	Vinyl	Leprous - Bilateral	Metal	Progressive Metal	Yes	40.0	50.00	111.52	155.02

	CollectionFolder	Record	Genre	Subgenre	Collection_Autographed	Collection_Cost	_Min_	_Median_	_Max_
302	Vinyl	Meshuggah - 25 Years Of Musical Deviance	Metal	Djent	No	232.0	389.00	514.17	799.99
54	Vinyl	Opeth - In Live Concert At The Royal Albert Hall	Metal	Progressive Metal	No	66.0	85.99	117.83	141.76
394	Vinyl	Cult Of Luna - A Dawn To Fear	Metal	Post Metal	No	66.0	27.47	54.74	58.23
201	Vinyl	Mastodon - Remission	Metal	Sludge Metal	No	55.0	45.00	81.97	143.90
254	Vinyl	Opeth - Book Of Opeth	Metal	Progressive Metal	No	50.0	6.57	59.28	97.80
288	Vinyl	Cult Of Luna - Salvation	Metal	Post Metal	No	45.0	24.00	51.12	56.18
294	Vinyl	Cult Of Luna - Somewhere Along The Highway	Metal	Post Metal	No	45.0	28.00	59.20	79.99
303	Vinyl	Sioum - Yet Further	Metal	Progressive Metal	No	40.0	NaN	NaN	NaN
122	Vinyl	Opeth - Ghost Reveries	Metal	Progressive Metal	No	40.0	20.00	24.98	32.18
202	Vinyl	Leprous - Bilateral	Metal	Progressive Metal	Yes	40.0	50.00	111.52	155.02
310	CD	Cult Of Luna - Years In A Day	Metal	Post Metal	No	40.0	11.65	20.50	32.99
168	CD	Skyharbor - Guiding Lights	Metal	Djent	Yes	30.0	10.00	11.83	14.86
107	CD	Tesseract - Altered State	Metal	Djent	No	17.0	13.00	32.00	39.99
88	CD	Scale The Summit - The Migration	Metal	Progressive Metal	No	15.0	2.00	7.07	11.54
18	CD	Kayo Dot - Choirs Of The Eye	Metal	Progressive Metal	Yes	15.0	6.66	10.19	16.37
151	CD	Cynic (2) - Kindly Bent To Free Us	Metal	Progressive Metal	No	14.0	5.33	7.38	17.17
30	CD	Cynic (2) - Traced In Air	Metal	Progressive Metal	No	14.0	6.00	9.63	14.43
61	CD	Cynic (2) - Carbon-Based Anatomy	Metal	Progressive Metal	No	12.0	4.95	7.00	9.81
94	CD	The Ocean (2) - Pelagial	Metal	Post Metal	No	12.0	7.69	12.50	14.99
58	CD	TesseracT - One	Metal	Djent	No	11.0	3.00	11.00	16.99
398	Tape	Krallice - Rot And Waste Live	Metal	Black Metal	No	10.0	NaN	NaN	NaN

What are the top 10 bands with the most expensive records purchased?

Plot top 10 bands that I purchased the most by cost

	Artist2	Title	Label	Collection_Cost	_Min_	_Median_	_Max_
35	Cult Of Luna	16	7	552.75	390.58	576.84	795.90
105	Opeth	19	13	533.00	419.55	660.02	1013.97
88	Meshuggah	2	1	260.00	403.00	546.67	839.98
111	Panopticon (6)	11	4	238.25	205.87	285.85	406.34
73	Isis (6)	12	4	217.00	214.61	317.39	492.03
38	Deathspell Omega	9	3	190.00	152.34	215.67	355.69
87	Mastodon	9	5	177.00	124.95	236.89	409.37
15	Between The Buried And Me	10	2	157.50	234.89	333.08	544.67
155	Thou (2)	9	9	137.00	123.96	180.03	246.03
112	Perturbator	5	2	130.00	116.89	178.00	261.04

What the most records purchased by the Top 10 bands?

	Artist2	Title	Label	Collection_Cost	_Min_	_Median_	_Max_
105	Opeth	19	13	533.00	419.55	660.02	1013.97
35	Cult Of Luna	16	7	552.75	390.58	576.84	795.90
73	Isis (6)	12	4	217.00	214.61	317.39	492.03
111	Panopticon (6)	11	4	238.25	205.87	285.85	406.34
15	Between The Buried And Me	10	2	157.50	234.89	333.08	544.67
87	Mastodon	9	5	177.00	124.95	236.89	409.37
38	Deathspell Omega	9	3	190.00	152.34	215.67	355.69
155	Thou (2)	9	9	137.00	123.96	180.03	246.03
80	Krallice	6	2	126.00	93.87	135.20	143.58
186	Yes	6	1	28.00	21.82	46.15	105.74

What are the top 10 most valuable record by min?

	Record	Collection_Cost	_Min_	_Median_	_Max_
302	Meshuggah - 25 Years Of Musical Deviance	232.0	389.00	514.17	799.99
54	Opeth - In Live Concert At The Royal Albert Hall	66.0	85.99	117.83	141.76
142	Haken (2) - The Mountain	22.0	64.84	81.20	109.88
86	Between The Buried And Me - The Parallax II: F...	30.0	60.00	70.00	113.64
341	Yellow Eyes (2) - Immersion Trench Reverie	15.0	60.00	69.50	79.00
340	Isis (6) - Live VII - 02.25.10	18.0	60.00	65.96	90.00
141	Opeth - Heritage	40.0	54.95	75.92	100.00
140	Between The Buried And Me - The Anatomy Of	21.0	54.95	78.50	165.00
139	Leprous - Coal	20.0	54.93	59.44	87.91
202	Leprous - Bilateral	40.0	50.00	111.52	155.02

What are the top 10 most valuable record by median?

	Record	Title	Subgenre	Collection_Cost	_Min_	_Median_	_Max_
302	Meshuggah - 25 Years Of Musical Deviance	25 Years Of Musical Deviance	Djent	232.0	389.00	514.17	799.99
54	Opeth - In Live Concert At The Royal Albert Hall	In Live Concert At The Royal Albert Hall	Progressive Metal	66.0	85.99	117.83	141.76
202	Leprous - Bilateral	Bilateral	Progressive Metal	40.0	50.00	111.52	155.02
201	Mastodon - Remission	Remission	Sludge Metal	55.0	45.00	81.97	143.90
142	Haken (2) - The Mountain	The Mountain	Progressive Metal	22.0	64.84	81.20	109.88
140	Between The Buried And Me - The Anatomy Of	The Anatomy Of	Progressive Metal	21.0	54.95	78.50	165.00
203	Ne Obliviscaris - Portal Of I	Portal Of I	Progressive Metal	30.0	50.00	77.81	250.00
141	Opeth - Heritage	Heritage	Progressive Metal	40.0	54.95	75.92	100.00
86	Between The Buried And Me - The Parallax II: F...	The Parallax II: Future Sequence	Progressive Metal	30.0	60.00	70.00	113.64
341	Yellow Eyes (2) - Immersion Trench Reverie	Immersion Trench Reverie	Black Metal	15.0	60.00	69.50	79.00

What are the top 10 most valuable record by max?

	Record	Collection_Cost	_Min_	_Median_	_Max_
302	Meshuggah - 25 Years Of Musical Deviance	232.0	389.00	514.17	799.99
203	Ne Obliviscaris - Portal Of I	30.0	50.00	77.81	250.00
81	Gorod - A Perfect Absolution	12.0	19.99	48.05	199.98
140	Between The Buried And Me - The Anatomy Of	21.0	54.95	78.50	165.00
202	Leprous - Bilateral	40.0	50.00	111.52	155.02
201	Mastodon - Remission	55.0	45.00	81.97	143.90
54	Opeth - In Live Concert At The Royal Albert Hall	66.0	85.99	117.83	141.76
2	The Dave Brubeck Quartet - Time Out	20.0	5.07	26.50	130.00
248	Opeth - Deliverance & Damnation	36.0	33.03	58.44	119.99
194	Opeth - Watershed	30.0	25.00	55.00	119.00

The Meshuggah boxset was sold for 514.17 and I bought it for 232.

What are the Top 10 albums sold by average?

	Artist2	Title	Label	Collection_Cost	_Min_	_Median_	_Max_
88	Meshuggah	2	1	130.000000	201.500000	273.335000	419.990000
83	Leprous	3	2	28.000000	42.586667	67.493333	95.106667
96	Ne Obliviscaris	2	2	25.000000	37.000000	54.520000	144.230000
150	The Contortionist (2)	4	3	20.625000	30.247500	54.057500	68.232500
3	Altar Of Plagues	1	1	36.500000	40.000000	49.990000	82.050000
56	Gojira (2)	1	1	30.000000	33.000000	48.490000	65.000000
185	Yellow Eyes (2)	2	1	16.500000	41.995000	47.075000	52.495000
31	Cloudkicker	1	1	15.000000	30.000000	46.980000	55.000000
171	Vildhjarta	2	2	17.500000	25.495000	46.385000	59.990000
12	Baroness	3	2	17.543333	29.680000	45.973333	66.583333

What are the Top 10 albums sold by max?

	Artist2	Title	Label	Collection_Cost	_Min_	_Median_	_Max_
88	Meshuggah	2	1	130.000	201.500000	273.335000	419.990000
96	Ne Obliviscaris	2	2	25.000	37.000000	54.520000	144.230000
151	The Dave Brubeck Quartet	1	1	20.000	5.070000	26.500000	130.000000
58	Gorod	2	1	14.000	15.995000	35.275000	114.990000
83	Leprous	3	2	28.000	42.586667	67.493333	95.106667
3	Altar Of Plagues	1	1	36.500	40.000000	49.990000	82.050000
1	Agalloch	1	1	30.000	16.000000	35.000000	70.650000
41	Devourment	1	1	13.630	20.000000	31.000000	69.990000
23	Carpenter Brut	1	1	36.000	32.610000	35.850000	69.980000
150	The Contortionist (2)	4	3	20.625	30.247500	54.057500	68.232500

	Artist2	Title	Collection_Cost	_Min_	_Median_	_Max_
54	Opeth	In Live Concert At The Royal Albert Hall	66.0	85.99	117.83	141.76
248	Opeth	Deliverance & Damnation	36.0	33.03	58.44	119.99
194	Opeth	Watershed	30.0	25.00	55.00	119.00
141	Opeth	Heritage	40.0	54.95	75.92	100.00
254	Opeth	Book Of Opeth	50.0	6.57	59.28	97.80
131	Opeth	Morningrise	6.0	26.00	35.00	65.21
32	Opeth	Orchid	22.0	19.47	32.61	43.48
238	Opeth	The Roundhouse Tapes	30.0	20.00	26.26	42.50
33	Opeth	My Arms, Your Hearse	6.0	20.00	33.33	41.11
273	Opeth	Lamentations Live At Shepherd's Bush Empire	30.0	15.05	28.05	39.98
52	Opeth	Blackwater Park	31.0	26.19	31.99	39.98
187	Opeth	Pale Communion	29.0	18.89	20.55	33.32
122	Opeth	Ghost Reveries	40.0	20.00	24.98	32.18
277	Opeth	Sorceress	20.0	18.67	24.00	31.00
82	Opeth	Still Life	32.0	20.31	21.18	30.99
21	Opeth	Lamentations - Live At Shepherd's Bush Empire ...	6.0	4.99	6.40	19.00
48	Opeth	The Roundhouse Tapes	9.0	4.44	9.20	16.67
399	Opeth	In Cauda Venenum	25.0	NaN	NaN	NaN
400	Opeth	In Cauda Venenum	25.0	NaN	NaN	NaN

Label Analysis

	Label	Artist2	Title	Collection_Cost	_Min_	_Median_	_Max_
113	Relapse Records	13	23	451.27	374.98	591.73	943.35
104	Nuclear Blast, Nuclear Blast	3	4	289.50	427.74	579.53	885.80
23	Century Media	10	17	346.00	275.26	458.06	650.54
17	Blood Music (2)	5	9	260.00	268.74	429.77	748.10
109	Prosthetic Records	6	13	221.00	164.36	271.41	391.61

Which record labels did I spend the most?

	Label	Artist2	Title	Collection_Cost	_Min_	_Median_	_Max_
113	Relapse Records	13	23	451.27	374.98	591.73	943.35
23	Century Media	10	17	346.00	275.26	458.06	650.54
104	Nuclear Blast, Nuclear Blast	3	4	289.50	427.74	579.53	885.80
17	Blood Music (2)	5	9	260.00	268.74	429.77	748.10
41	Earache	4	9	230.74	160.17	260.32	319.41
109	Prosthetic Records	6	13	221.00	164.36	271.41	391.61
66	Indie Recordings	1	5	175.00	124.12	170.59	269.45
52	Gilead Media	4	9	172.50	200.85	260.41	300.35
1	20 Buck Spin	8	10	169.00	134.06	200.41	267.73
91	Nordvis Produktion, Bindrune Recordings	3	7	164.00	170.63	214.93	296.49

Index(['ID', 'Catalog#', 'Artist', 'Artist2', 'Title', 'Label', 'Format',
       'Released', 'release_id', 'CollectionFolder', 'Date_Added',
       'Collection_Cost', 'Collection_Autographed', '_Min_', '_Median_',
       '_Max_', 'Genre', 'Subgenre', 'Label1', 'Label2', 'Label3', 'Label4',
       'Record'],
      dtype='object')

0    07/2019
1    12/2016
2    05/2014
3    04/2017
4    02/2020
Name: Date_Added, dtype: object

Time Series

Group data by Released and Date_Added then get sum by Collection_Cost, _Min_, _Median_, and _Max_.

	Released	Date_Added	Collection_Cost	Artist	Artist2	Title	_Min_	_Median_	_Max_
60	2012	01/2014	12.00	1	1	1	4.66	12.05	19.69
73	2013	01/2014	68.00	4	4	5	106.05	161.86	223.85
48	2011	01/2014	8.00	1	1	1	8.86	11.09	15.38
92	2014	01/2015	52.00	2	2	2	28.50	72.73	95.91
127	2016	01/2016	20.72	1	1	1	16.56	23.66	33.00

Plot Date_Added over Collection_Cost

Plot Date_Added over Title

Plot Date_Added over Artist2

There were some days that I logged many records at once on discogs.

Group data by Released

	Released	Artist2	Title	CollectionFolder	Genre	Subgenre	Collection_Cost	_Min_	_Median_	_Max_
0	1961	1	1	1	1	1	20.0	5.07	26.50	130.00
1	1971	1	1	1	1	1	5.5	2.25	3.87	10.00
2	1973	2	2	2	2	2	10.5	11.94	23.48	40.00
3	1974	1	1	1	1	1	4.0	1.13	7.00	30.74
4	1975	1	1	1	1	1	12.0	10.00	17.00	25.00

count      32.0000
mean     1998.2500
std        17.5683
min      1961.0000
25%      1979.7500
50%      2004.5000
75%      2012.2500
max      2020.0000
Name: Released, dtype: float64

<seaborn.axisgrid.FacetGrid at 0x12ee73610>

<seaborn.axisgrid.FacetGrid at 0x12ce6bfd0>

<seaborn.axisgrid.FacetGrid at 0x12cd35c90>

<seaborn.axisgrid.FacetGrid at 0x12de77b90>

<seaborn.axisgrid.FacetGrid at 0x12cdbf150>

Genre and Subgenre analysis

Metal         358
Rock           31
Electronic     12
Pop             3
Hip Hop         2
Jazz            1
Folk            1
Name: Genre, dtype: int64

Remove records less than 2

['Metal', 'Rock', 'Electronic', 'Pop']

	ID	Catalog#	Artist	Artist2	Title	Label	Format	Released	release_id	CollectionFolder	Date_Added	Collection_Cost	Collection_Autographed	_Min_	_Median_	_Max_	Genre	Subgenre	Label1	Label2	Label3	Label4	Record
0	33	SD 8283	Yes	Yes	The Yes Album	Atlantic	LP, Album, RE, PR;	1971	7116823.0	Vinyl	07/2019	5.5	No	2.25	3.87	10.00	Rock	Progressive Rock	Atlantic	None	None	None	Yes - The Yes Album
1	165	RR 6583-1	Mastodon	Mastodon	Remission	Relapse Records	2x12", Album, RE, RM, RP	2017	8863478.0	Vinyl	12/2016	15.0	No	7.99	21.67	30.19	Metal	Sludge Metal	Relapse Records	None	None	None	Mastodon - Remission
3	142	SD 3-100	Yes	Yes	Yessongs	Atlantic	3xLP, Album	1973	8179158.0	Vinyl	04/2017	5.0	No	3.95	9.99	20.00	Rock	Progressive Rock	Atlantic	None	None	None	Yes - Yessongs
4	18	SD 2-908	Yes	Yes	Tales From Topographic Oceans	Atlantic	2xLP, Album, Gat	1973	8535940.0	Vinyl	02/2020	5.5	No	7.99	13.49	20.00	Rock	Progressive Rock	Atlantic	None	None	None	Yes - Tales From Topographic Oceans
5	340	SD 18122	Yes	Yes	Relayer	Atlantic	LP, Album, Gat	1974	755646.0	Vinyl	09/2014	4.0	No	1.13	7.00	30.74	Rock	Progressive Rock	Atlantic	None	None	None	Yes - Relayer

Metal         357
Rock           31
Electronic     12
Pop             3
Name: Genre, dtype: int64

Boxplot Genre by Collection_Cost, Min, Median, and Max

Subgenre Analysis

Black Metal              83
Progressive Metal        62
Post Metal               61
Djent                    26
Sludge Metal             26
Death Metal              21
Doom Metal               17
Grindcore                16
Technical Death Metal    15
Hardcore                 13
Outrun                    9
Progressive Rock          7
Heavy Metal               7
Alternative Rock          6
Thrash Metal              5
Grunge                    3
Synthpop                  3
Folk                      3
Classic Rock              3
Shoegaze                  2
Post Hardcore             2
Hip Hop                   2
Stoner Metal              2
Psychdelic                2
Melodic Death Metal       2
Pop                       2
Rock                      1
Synthwave                 1
Metalcore                 1
Noise Rock                1
Post Rock                 1
Jazz                      1
Gothic Metal              1
Name: Subgenre, dtype: int64

['Black Metal',
 'Progressive Metal',
 'Post Metal',
 'Djent',
 'Sludge Metal',
 'Death Metal',
 'Doom Metal',
 'Grindcore',
 'Technical Death Metal',
 'Hardcore',
 'Outrun',
 'Progressive Rock',
 'Heavy Metal',
 'Alternative Rock']

	ID	Catalog#	Artist	Artist2	Title	Label	Format	Released	release_id	CollectionFolder	Date_Added	Collection_Cost	Collection_Autographed	_Min_	_Median_	_Max_	Genre	Subgenre	Label1	Label2	Label3	Label4	Record
0	33	SD 8283	Yes	Yes	The Yes Album	Atlantic	LP, Album, RE, PR;	1971	7116823.0	Vinyl	07/2019	5.5	No	2.25	3.87	10.00	Rock	Progressive Rock	Atlantic	None	None	None	Yes - The Yes Album
1	165	RR 6583-1	Mastodon	Mastodon	Remission	Relapse Records	2x12", Album, RE, RM, RP	2017	8863478.0	Vinyl	12/2016	15.0	No	7.99	21.67	30.19	Metal	Sludge Metal	Relapse Records	None	None	None	Mastodon - Remission
3	142	SD 3-100	Yes	Yes	Yessongs	Atlantic	3xLP, Album	1973	8179158.0	Vinyl	04/2017	5.0	No	3.95	9.99	20.00	Rock	Progressive Rock	Atlantic	None	None	None	Yes - Yessongs
4	18	SD 2-908	Yes	Yes	Tales From Topographic Oceans	Atlantic	2xLP, Album, Gat	1973	8535940.0	Vinyl	02/2020	5.5	No	7.99	13.49	20.00	Rock	Progressive Rock	Atlantic	None	None	None	Yes - Tales From Topographic Oceans
5	340	SD 18122	Yes	Yes	Relayer	Atlantic	LP, Album, Gat	1974	755646.0	Vinyl	09/2014	4.0	No	1.13	7.00	30.74	Rock	Progressive Rock	Atlantic	None	None	None	Yes - Relayer

Boxplot Subgenre by Collection_Cost, Min, Median, and Max

[Text(0, 0, 'Progressive Rock'),
 Text(0, 0, 'Sludge Metal'),
 Text(0, 0, 'Heavy Metal'),
 Text(0, 0, 'Progressive Metal'),
 Text(0, 0, 'Hardcore'),
 Text(0, 0, 'Post Metal'),
 Text(0, 0, 'Alternative Rock'),
 Text(0, 0, 'Grindcore'),
 Text(0, 0, 'Black Metal'),
 Text(0, 0, 'Doom Metal'),
 Text(0, 0, 'Djent'),
 Text(0, 0, 'Technical Death Metal'),
 Text(0, 0, 'Death Metal'),
 Text(0, 0, 'Outrun')]

Reduce to Top 5 subgenres

	ID	Catalog#	Artist	Artist2	Title	Label	Format	Released	release_id	CollectionFolder	Date_Added	Collection_Cost	Collection_Autographed	_Min_	_Median_	_Max_	Genre	Subgenre	Label1	Label2	Label3	Label4	Record
1	165	RR 6583-1	Mastodon	Mastodon	Remission	Relapse Records	2x12", Album, RE, RM, RP	2017	8863478.0	Vinyl	12/2016	15.0	No	7.99	21.67	30.19	Metal	Sludge Metal	Relapse Records	None	None	None	Mastodon - Remission
14	275	RR 6427-2	The Dillinger Escape Plan	The Dillinger Escape Plan	Calculating Infinity	Relapse Records	CD, Album	1999	5536513.0	CD	06/2015	1.0	No	0.86	5.51	11.99	Metal	Progressive Metal	Relapse Records	None	None	None	The Dillinger Escape Plan - Calculating Infinity
16	375	IPC-32	Isis (6)	Isis (6)	Oceanic	Ipecac Recordings	CD, Album	2002	376473.0	CD	03/2014	7.0	No	4.58	6.33	12.97	Metal	Post Metal	Ipecac Recordings	None	None	None	Isis (6) - Oceanic
18	146	TZ 7092	Kayo Dot	Kayo Dot	Choirs Of The Eye	Tzadik	CD, Album, Cre	2003	649369.0	CD	04/2017	15.0	Yes	6.66	10.19	16.37	Metal	Progressive Metal	Tzadik	None	None	None	Kayo Dot - Choirs Of The Eye
20	325	IPC-57	Isis (6)	Isis (6)	Panopticon	Ipecac Recordings	CD, Album	2004	377605.0	CD	11/2014	7.0	No	4.55	9.91	11.99	Metal	Post Metal	Ipecac Recordings	None	None	None	Isis (6) - Panopticon

Boxplot Reduced Subgenre by Collection_Cost, Min, Median, and Max

[Text(0, 0, 'Sludge Metal'),
 Text(0, 0, 'Progressive Metal'),
 Text(0, 0, 'Post Metal'),
 Text(0, 0, 'Black Metal'),
 Text(0, 0, 'Djent')]

3D Plot of Collection_Cost, Median, and Max

Plot Collection_Cost vs Median by Subgenre

Plot Collection_Cost, Min, Median, and Max by Subgenre

Distribution Plot Collection Cost by Subgenre

Distribution plot Min by Subgenre

Distribution Plot Median by Subgenre

Distribution Plot Max by Subgenre

Format Analysis

What are my top 10 valuable records by format?

	CollectionFolder	Record	Genre	Subgenre	Collection_Autographed	Collection_Cost	_Median_
302	Vinyl	Meshuggah - 25 Years Of Musical Deviance	Metal	Djent	No	232.0	514.17
54	Vinyl	Opeth - In Live Concert At The Royal Albert Hall	Metal	Progressive Metal	No	66.0	117.83
202	Vinyl	Leprous - Bilateral	Metal	Progressive Metal	Yes	40.0	111.52
201	Vinyl	Mastodon - Remission	Metal	Sludge Metal	No	55.0	81.97
142	Vinyl	Haken (2) - The Mountain	Metal	Progressive Metal	Yes	22.0	81.20
140	Vinyl	Between The Buried And Me - The Anatomy Of	Metal	Progressive Metal	No	21.0	78.50
203	Vinyl	Ne Obliviscaris - Portal Of I	Metal	Progressive Metal	Yes	30.0	77.81
141	Vinyl	Opeth - Heritage	Metal	Progressive Metal	Yes	40.0	75.92
86	Vinyl	Between The Buried And Me - The Parallax II: F...	Metal	Progressive Metal	No	30.0	70.00
341	Vinyl	Yellow Eyes (2) - Immersion Trench Reverie	Metal	Black Metal	No	15.0	69.50
340	Vinyl	Isis (6) - Live VII - 02.25.10	Metal	Post Metal	No	18.0	65.96
186	Vinyl	The Contortionist (2) - Language	Metal	Djent	Yes	15.0	65.11
135	Vinyl	Vildhjarta - Thousands Of Evils	Metal	Djent	No	18.0	62.78
250	Vinyl	The Contortionist (2) - Exoplanet	Metal	Djent	No	25.5	60.12
138	Vinyl	The Contortionist (2) - Intrinsic	Metal	Djent	No	15.0	60.00
139	Vinyl	Leprous - Coal	Metal	Progressive Metal	Yes	20.0	59.44
254	Vinyl	Opeth - Book Of Opeth	Metal	Progressive Metal	No	50.0	59.28
294	Vinyl	Cult Of Luna - Somewhere Along The Highway	Metal	Post Metal	No	45.0	59.20
248	Vinyl	Opeth - Deliverance & Damnation	Metal	Progressive Metal	No	36.0	58.44
137	Vinyl	Tesseract - Altered State	Metal	Djent	No	20.0	57.77
107	CD	Tesseract - Altered State	Metal	Djent	No	17.0	32.00
190	CD	Son Of Aurelius - Under A Western Sun	Metal	Progressive Metal	Yes	8.0	21.59
310	CD	Cult Of Luna - Years In A Day	Metal	Post Metal	No	40.0	20.50
123	CD	Uneven Structure - 8	Metal	Djent	No	8.0	20.00
177	CD	Alterbeast - Immortal	Metal	Technical Death Metal	Yes	10.0	15.55
267	CD	Saor - Guardians	Metal	Black Metal	Yes	10.0	14.18
165	CD	Saor - Aura	Metal	Black Metal	Yes	10.0	13.33
76	CD	Bongripper - The Great Barrier Reefer	Metal	Doom Metal	No	5.0	13.16
38	CD	Sólstafir - Köld	Metal	Post Metal	No	5.0	12.78
101	CD	Vestiges - The Descent Of Man	Metal	Black Metal	No	8.0	12.68
94	CD	The Ocean (2) - Pelagial	Metal	Post Metal	No	12.0	12.50
158	CD	Archspire - The Lucid Collective	Metal	Technical Death Metal	No	7.0	11.94
36	CD	Xasthur - All Reflections Drained	Metal	Black Metal	No	2.0	11.92
168	CD	Skyharbor - Guiding Lights	Metal	Djent	Yes	30.0	11.83
62	CD	Fallujah - The Harvest Wombs	Metal	Technical Death Metal	No	10.0	11.49
64	CD	Haken (2) - Visions	Metal	Progressive Metal	No	10.0	11.11
65	CD	Uneven Structure - Februus	Metal	Djent	No	8.0	11.09
58	CD	TesseracT - One	Metal	Djent	No	11.0	11.00
150	CD	Bongripper - Hippie Killer	Metal	Doom Metal	No	5.0	10.49
18	CD	Kayo Dot - Choirs Of The Eye	Metal	Progressive Metal	Yes	15.0	10.19

Autographed Analysis

	CollectionFolder	Record	Genre	Subgenre	Collection_Autographed	Collection_Cost	_Min_	_Median_	_Max_
203	Vinyl	Ne Obliviscaris - Portal Of I	Metal	Progressive Metal	Yes	30.0	50.00	77.81	250.00
202	Vinyl	Leprous - Bilateral	Metal	Progressive Metal	Yes	40.0	50.00	111.52	155.02
199	Vinyl	Isis (6) - Oceanic	Metal	Post Metal	Yes	22.0	29.00	49.49	109.89
142	Vinyl	Haken (2) - The Mountain	Metal	Progressive Metal	Yes	22.0	64.84	81.20	109.88
141	Vinyl	Opeth - Heritage	Metal	Progressive Metal	Yes	40.0	54.95	75.92	100.00
186	Vinyl	The Contortionist (2) - Language	Metal	Djent	Yes	15.0	17.00	65.11	89.95
139	Vinyl	Leprous - Coal	Metal	Progressive Metal	Yes	20.0	54.93	59.44	87.91
280	Vinyl	Perturbator - The Uncanny Valley	Electronic	Outrun	Yes	30.0	19.63	38.70	79.99
127	Vinyl	Intronaut - Valley Of Smoke	Metal	Post Metal	Yes	20.0	22.99	40.00	76.92
128	Vinyl	Falls Of Rauros - The Light That Dwells In Rot...	Metal	Black Metal	Yes	18.0	23.07	37.92	66.91
177	CD	Alterbeast - Immortal	Metal	Technical Death Metal	Yes	10.0	13.33	15.55	38.89
190	CD	Son Of Aurelius - Under A Western Sun	Metal	Progressive Metal	Yes	8.0	20.00	21.59	23.19
267	CD	Saor - Guardians	Metal	Black Metal	Yes	10.0	12.09	14.18	18.66
18	CD	Kayo Dot - Choirs Of The Eye	Metal	Progressive Metal	Yes	15.0	6.66	10.19	16.37
165	CD	Saor - Aura	Metal	Black Metal	Yes	10.0	8.89	13.33	15.38
168	CD	Skyharbor - Guiding Lights	Metal	Djent	Yes	30.0	10.00	11.83	14.86

	Released	Subgenre	Artist2	Title	Collection_Cost	_Min_	_Median_	_Max_
0	1999	Progressive Metal	1	1	1.0	0.86	5.51	11.99
1	2002	Post Metal	1	1	7.0	4.58	6.33	12.97
2	2003	Progressive Metal	1	1	15.0	6.66	10.19	16.37
3	2004	Post Metal	1	1	7.0	4.55	9.91	11.99
4	2004	Progressive Metal	1	1	6.0	4.99	6.40	19.00

Subgenre	Black Metal	Djent	Post Metal	Progressive Metal	Sludge Metal
Released
2016	194.0	28.0	285.0	197.0	36.0
2017	145.0	82.0	266.0	37.0	15.0
2018	207.0	NaN	79.0	NaN	75.0
2019	384.0	NaN	66.0	50.0	NaN
2020	36.0	NaN	NaN	NaN	NaN

Subgenre	Black Metal	Djent	Post Metal	Progressive Metal	Sludge Metal
Released
2016	11.0	1.0	11.0	7.0	2.0
2017	8.0	3.0	9.0	2.0	1.0
2018	9.0	NaN	3.0	NaN	5.0
2019	19.0	NaN	1.0	2.0	NaN
2020	2.0	NaN	NaN	NaN	NaN

	Released	Genre	Artist2	Title	Collection_Cost	_Min_	_Median_	_Max_
0	1961	Jazz	1	1	20.0	5.07	26.50	130.00
1	1971	Rock	1	1	5.5	2.25	3.87	10.00
2	1973	Rock	2	2	10.5	11.94	23.48	40.00
3	1974	Rock	1	1	4.0	1.13	7.00	30.74
4	1975	Rock	1	1	12.0	10.00	17.00	25.00